USE [BMIG_MENSUAL_POST_CADENA]

 -- creating the store procedure
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = 'WASP_M0007_COMISION_SEGUROSIP'
	   AND 	  type = 'P') 
	DROP PROCEDURE [dbo].[WASP_M0007_COMISION_SEGUROSIP]
GO
CREATE PROCEDURE [dbo].[WASP_M0007_COMISION_SEGUROSIP] AS
begin
  SELECT cs.ppsuc
    , cs.ppcta
    , cs.ppoper
    , vs.ppimp11 AS cod_seg1
    , cs.ppimp11 AS val_seg1
    , vs.ppimp12 AS cod_seg2
    , cs.ppimp12 AS val_seg2
    , vs.ppimp13 AS cod_seg3
    , cs.ppimp13 AS val_seg3
    , vs.ppimp14 AS cod_seg4
    , cs.ppimp14 AS val_seg4
    , vs.ppimp15 AS cod_seg5
    , cs.ppimp15 AS val_seg5
    , vs.ppimp16 AS cod_seg6
    , cs.ppimp16 AS val_seg6
    , vs.ppimp17 AS cod_seg7
    , cs.ppimp17 AS val_seg7
    , vs.ppimp18 AS cod_seg8
    , cs.ppimp18 AS val_seg8
    , vs.ppimp19 AS cod_seg9
    , cs.ppimp19 AS val_seg9
    into dbo.cabecera_comision_segurosIP_ant
    FROM dbo.cabecera_valores_segurosIP_ant AS cs 
      CROSS JOIN dbo.cabecera_codigos_segurosIP_ant AS vs
    WHERE (cs.ppsuc = vs.ppsuc) 
      AND (cs.ppcta = vs.ppcta) 
      AND (cs.ppoper = vs.ppoper)
      ORDER BY cod_seg1
End  